Range Samples |
Add a variety of formatting, comments, grouping, hyperlinks, protection, validation, values,
and merge, find, replace, filter, sort, goal seek, or fill data.
|
|
Border |
Set border style, weight and color. |
|
Comment |
Add cell comments to a worksheet. |
|
Hyperlink |
Add hyperlinks to worksheet cells. |
|
Interior |
Set fill pattern and color. |
|
Merge Cells |
Merge the currently selected range. |
|
Number Format |
Set number formats. |
|
Orientation |
Set text orientation. |
|
Auto Filter |
Use auto filters to view subsets of data in a worksheet. |
|
Sorting |
Sort a range of data. |
|
Validation |
Add data validation to worksheet cells. |
|
Conditional Format |
Add conditional formats based on specific criteria. |
|
Goal Seek |
Achieve a specific goal from a calculated result using a simple iterative linear search. |
|
Fill Data Series |
Automatically fill cells with data. |
|
Find and Replace |
Find and replace values in worksheet ranges. |
|
Group and Outline |
Group and outline ranges of cells. |
|
Lock and Protect |
Lock and unlock cells and enable worksheet protection. |
|
Values from Array |
Set cell values from an array. |
|